package org.dey.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.dey.pojo.FormulateScheme;
import org.dey.pojo.Member;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author hg
 * @date 2022/4/4
 * @classname
 */
@Repository
public interface FormulateSchemeMapper extends BaseMapper<FormulateScheme> {

    @Select(" SELECT rqfl.id rqflid,rqfl.itid rqflitid ,tm.*\n" +
            " FROM renqunfenlei rqfl INNER JOIN t_member tm \n" +
            " ON rqfl.member = tm.`id` WHERE rqfl.zhuangtai = \"未干预\"")
    List<Member> memberiXx();
}
